select a.target_ledger_id ledger_id, a.target_ledger_name name,
       b.currency_code currency_code,
       b.sla_accounting_method_code SLAM, a.target_ledger_category_code type
from   gl_ledger_relationships a,
       gl_ledgers b
where  a.primary_ledger_id = (select set_of_books_id
                              from   ar_adjustments_all
                              where  adjustment_id = 345975)
and    a.primary_ledger_id = b.ledger_id

select *
from   ar_system_parameters_all
where  org_id  = (select org_id
                  from   ar_adjustments_all
                  where  adjustment_id = 345975)

SELECT accounting_method_code SLAM_code, amb_context_code,
substr(rpad(ACCOUNTING_METHOD_TYPE_CODE,8,' '),1,8) SLAM_type,
product_rule_code AAD_code,
product_rule_name AAD_name,
substr(rpad(product_rule_type_code,8,' '),1,8) AAD_type,
to_char(last_update_date, 'YYYY-MON-DD HH24:MI:SS')  last_update_date,
to_char(creation_date, 'YYYY-MON-DD HH24:MI:SS')  creation_date ,
to_char(start_date_active, 'YYYY-MON-DD')  start_date,
to_char(end_date_active,'YYYY-MON-DD') end_date,
application_id app_id,
last_updated_by,
created_by
FROM    xla_acctg_method_rules_fvl
where   application_id = 222
and    accounting_method_code IN
      (select sla_accounting_method_code
       from   gl_ledgers
       where  ledger_id = (select set_of_books_id
                           from   ar_adjustments_all
                           where  adjustment_id = 345975)
      )

select PRODUCT_RULE_CODE, name,
       to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS') creation_date ,
       to_char(last_update_date, 'DD-MON-YYYY HH24:MI:SS') last_update,
       decode(COMPILE_STATUS_CODE,'Y','Compiled',
                                  'N','Not Compiled',
                                  'I','Invalid',
                                  'R','Validating',
                                  'Invalid - '||COMPILE_STATUS_CODE) STATUS_CODE,
      'XLA_00222_AAD_'||product_rule_type_code||'_00000'||product_rule_hash_id||'_PKG' AAD_Package,
      PRODUCT_RULE_HASH_ID,
      enabled_flag
      PRODUCT_RULE_TYPE_CODE,
      created_by,
      last_updated_by
from   xla_product_rules_fvl
where  application_id = 222
and    (PRODUCT_RULE_CODE, amb_context_code) in
              (SELECT PRODUCT_RULE_CODE, amb_context_code
               FROM xla_acctg_method_rules_fvl
               WHERE upper(application_name)='RECEIVABLES'
               and   amb_context_code = 'DEFAULT'
               and   accounting_method_code IN
                (select sla_accounting_method_code
                 from gl_ledgers
                 where ledger_id = (select set_of_books_id
                                    from   ar_adjustments_all
                                    where  adjustment_id = 345975)
      ))

SELECT decode(FND_PROFILE.value('AR_MFAR_ACTIVATED'),
       'Y','YES','N','NO','NULL') MFAR_Extract_Profile
from dual

SELECT a.filename, b.version,
to_char(b.creation_date,'YYYY/MM/DD') applied_date
FROM ad_files a,
ad_file_versions b
WHERE a.file_id = b.file_id
AND a.subdir = 'patch/115/import/US'
AND a.filename = 'ARXLAAAD.ldt'
ORDER BY 3 desc

select name, text, type
from   dba_source
where  name = 'XLA_TRANSFER_PKG'
and    line = 2

SELECT *
from AR_ADJUSTMENTS_ALL
where adjustment_id = 345975

SELECT *
from   AR_DISTRIBUTIONS_ALL
where  source_id  in (select adjustment_id
                      from   ar_adjustments_all
                      where  adjustment_id = 345975)
and    source_table = 'ADJ'
order by line_id

SELECT   dis.source_table,
         sum(dis.amount_dr),
         sum(dis.amount_cr),
         sum(dis.acctd_amount_dr),
         sum(dis.acctd_amount_cr),
         sum(dis.from_amount_dr),
         sum(dis.from_amount_cr),
         sum(dis.from_acctd_amount_dr),
         sum(dis.from_acctd_amount_cr)
FROM     AR_DISTRIBUTIONS_ALL dis,
         AR_ADJUSTMENTS_ALL adj
WHERE    adj.adjustment_id = 345975
AND      dis.source_table = 'ADJ'
AND      dis.source_id    = adj.adjustment_id
GROUP BY dis.source_table

SELECT code_combination_id, concatenated_segments account,
       gl_control_account control_account,
       enabled_flag enabled,
       detail_posting_allowed detail_posting, alternate_code_combination_id,
       start_date_active start_date,
       end_date_active end_date
from   gl_code_combinations_kfv
where  code_combination_id in (select distinct code_combination_id
                               from   ar_distributions_all
                               where  source_id = 345975
                               and    source_table = 'ADJ')

SELECT *
FROM   xla.xla_transaction_entities
WHERE  application_id = 222
AND    entity_code in ('ADJUSTMENTS','MANUAL')
and    nvl(source_id_int_1,-99) = 345975
order by entity_id

SELECT *
FROM   XLA_EVENTS
WHERE  application_id = 222
and    entity_id in
       (SELECT entity_id
        FROM   xla.xla_transaction_entities xte
        WHERE  xte.application_id = 222
        AND    xte.entity_code in ('ADJUSTMENTS','MANUAL')
        and    nvl(source_id_int_1,-99) = 345975)
order  by event_id

SELECT *
FROM  XLA_AE_HEADERS
WHERE application_id = 222
and   entity_id in (SELECT entity_id
                    FROM   xla.xla_transaction_entities xte
                    WHERE  xte.application_id = 222
                    AND    xte.entity_code in ('ADJUSTMENTS','MANUAL')
                    and    nvl(source_id_int_1,-99) = 345975)
order  by ae_header_id

SELECT *
FROM   XLA_AE_LINES
WHERE  ae_header_id in (select ae_header_id
                        from   xla_ae_headers
                        where  application_id = 222
                        and    entity_id in (SELECT entity_id
                                             FROM   xla.xla_transaction_entities xte
                                             WHERE  xte.application_id = 222
                                             AND    xte.entity_code in ('ADJUSTMENTS','MANUAL')
                                             and    nvl(source_id_int_1,-99) = 345975)
                        )
order by ae_header_id, ae_line_num

SELECT code_combination_id, concatenated_segments account,
       gl_control_account control_account,
       enabled_flag enabled,
       detail_posting_allowed detail_posting, alternate_code_combination_id,
       start_date_active start_date,
       end_date_active end_date
from   gl_code_combinations_kfv
where  code_combination_id in (select distinct code_combination_id
                               from   xla_ae_lines
                               WHERE  ae_header_id in (select ae_header_id
                                                       from   xla_ae_headers
                                                       where  application_id = 222
                                                       and    entity_id in (SELECT entity_id
                                                                            FROM   xla.xla_transaction_entities xte
                                                                            WHERE  xte.application_id = 222
                                                                            AND    xte.entity_code in ('ADJUSTMENTS','MANUAL')
                                                                            and    nvl(source_id_int_1,-99) = 345975)
                                                        )
                                )

SELECT *
FROM   XLA_DISTRIBUTION_LINKS
WHERE  ae_header_id in (select ae_header_id
                        from   xla_ae_headers
                        where  application_id = 222
                        and    entity_id in (SELECT entity_id
                                             FROM   xla.xla_transaction_entities xte
                                             WHERE  xte.application_id = 222
                                             AND    xte.entity_code in ('ADJUSTMENTS','MANUAL')
                                             and    nvl(source_id_int_1,-99) = 345975)
                        )
order by ae_header_id, ae_line_num

select *
from   xla_accounting_errors
where  event_id  in
                (SELECT event_id
                 FROM   xla_events xe,
                        xla.xla_transaction_entities xte
                 WHERE  xte.application_id = 222
                 AND    xe.entity_id = xte.entity_id
                 AND    xe.process_status_code = 'I'
                 AND    xte.entity_code in ('ADJUSTMENTS','MANUAL')
                 AND    nvl(source_id_int_1,-99) = 345975)
order by event_id

SELECT *
    from RA_CUSTOMER_TRX_ALL
    where customer_trx_id =
            (select customer_trx_id
             from   ar_adjustments_all
             where  adjustment_id = 345975)

SELECT *
from RA_BATCH_SOURCES_ALL a,
     RA_CUSTOMER_TRX_ALL b
where a.batch_source_id = b.batch_source_id
and   b.customer_trx_id = (select customer_trx_id
                           from   ar_adjustments_all
                           where  adjustment_id = 345975)
and   b.org_id = a.org_id

SELECT *
    from RA_CUST_TRX_TYPES_ALL a,
         RA_CUSTOMER_TRX_ALL b
    where a.cust_trx_type_id = b.cust_trx_type_id
    and   b.customer_trx_id = (select customer_trx_id
                               from   ar_adjustments_all
                               where  adjustment_id = 345975)
    and   b.org_id = a.org_id

SELECT *
from RA_CUSTOMER_TRX_LINES_ALL
where customer_trx_id = (select customer_trx_id
                         from   ar_adjustments_all
                         where  adjustment_id = 345975)
order by customer_trx_line_id